| StudentRefundCalculation |
| EntityType | Independent |
| Logical Entity Name | StudentRefundCalculation |
| Default Table Name | SaRefundCalc |
| Logical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| StudentRefundCalculation Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
StudentRefundCalculationId |
INTEGER | NO | ||
StudentEnrollmentPeriodId |
INTEGER | YES | ||
| EffectiveDate | DATETIME | YES | ||
| CalculationDate | DATETIME | YES | ||
| Description | VARCHAR(50) | NO | ||
| Type | CHAR(1) | NO | ||
| Status | CHAR(1) | NO | ||
| CalculationPeriod | CHAR(1) | NO | ||
TermId |
INTEGER | YES | ||
| AcademicYearSequence | TINYINT | YES | ||
| Note | VARCHAR(2000) | YES | ||
| RefundsPayableDueDate | DATETIME | YES | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| LastModifiedUserId | INTEGER | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
StudentRt4CalculationId |
INTEGER | YES | ||
| LastDateOfAttendance | DATETIME | YES | ||
| IsRt4CalculationNotRequired | BIT | NO | ||
| EligibilityStatus | CHAR(1) | NO | ||
| IsCalculationAutoApproved | BIT | NO | ||
RefundCalculationStatusId |
INTEGER | YES | ||
RefundCalculationActionId |
INTEGER | YES | ||
| ApprovedDate | DATETIME | YES | ||
| NSLDSWithdrawalDate | DATETIME | YES | ||
StudentAcademicYearPaymentPeriodId |
INTEGER | YES | ||
| Rt4CalculationPeriod | CHAR(1) | YES | ||
| CeasedAttendingDate | DATETIME | YES | ||
StudentAcademicYearPaymentPeriodId |
INTEGER | YES |
| StudentRefundCalculation Keys |
| Key Name | Key Type | Keys |
| SaRefundCalc_SaRefundCalcID_U_C_IDX | PrimaryKey | StudentRefundCalculationId |
| SaRefundCalc_FaStudentAyPaymentPeriodId_N_N_IDX | Inversion Entry | StudentAcademicYearPaymentPeriodId |
| Nk_SaRefundCalcSaRefundCalculationStatusId_SaRefundCalculationStatusSaRefundCalculationStatusId | Inversion Entry | RefundCalculationStatusId |
| StudentRefundCalculation Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| StudentAcademicYearPaymentPeriod | Non-Identifying | Zero or One to Zero or More | StudentAcademicYearPaymentPeriodId | NO | |||
| RefundCalculationAction | Non-Identifying | Zero or One to Zero or More | RefundCalculationActionId | NO | |||
| RefundCalculationStatus | Non-Identifying | Zero or One to Zero or More | RefundCalculationStatusId | NO | |||
| RefundCalculationAction | Non-Identifying | Zero or One to Zero or More | RefundCalculationActionId | NO | |||
| RefundCalculationStatus | Non-Identifying | Zero or One to Zero or More | RefundCalculationStatusId | NO | |||
| StudentAcademicYearPaymentPeriod | Non-Identifying | Zero or One to Zero or More | StudentAcademicYearPaymentPeriodId | NO | |||
| StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More | StudentEnrollmentPeriodId | NO | |||
| StudentRt4Calculation | Non-Identifying | Zero or One to Zero or More | StudentRt4CalculationId | NO | |||
| Term | Non-Identifying | Zero or One to Zero or More | TermId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| SaRefundCalcStudentGroup_FAA | Non-Identifying | One To Zero or More | NO | ||||
| SaRefundCalcStudentGroup | Non-Identifying | One To Zero or More | NO | ||||
| SaRefundCalculationAssignment | Non-Identifying | One To Zero or More | NO | ||||
| SaRefundCalculationWorkflowAudit | Non-Identifying | One To Zero or More | NO | ||||
| Refund | Non-Identifying | One To Zero or More | NO | ||||
| StipendSchedule | Non-Identifying | One To Zero or More | NO | ||||
| StudentRefundCalculationPolicySummary | Non-Identifying | One To Zero or More | NO |
| StudentRefundCalculation Check Constraints |
| Check Constraint Name | CheckConstraint |
| StudentRefundCalculation Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.StudentRefundCalculation |
NO | |||
| Physical (Microsoft SQL Server) dbo.SaRefundCalc |
NO |
| StudentRefundCalculation Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | RefundCalculation |
| Logical | Refunds_Stipends |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Student Accounts |
| StudentRefundCalculation Data Movement Rules |
| Name | Type | Rule Text/Value |